databaseChangeLog = {

	changeSet(author: "mark (generated)", id: "1358528772974-1") {
		createTable(tableName: "contact") {
			column(autoIncrement: "true", name: "id", type: "BIGINT") {
				constraints(nullable: "false", primaryKey: "true")
			}

			column(name: "version", type: "BIGINT") {
				constraints(nullable: "false")
			}

			column(name: "cell_phone", type: "VARCHAR(255)")

			column(name: "email", type: "VARCHAR(255)") {
				constraints(nullable: "false")
			}

			column(name: "mailing_address_address1", type: "VARCHAR(255)") {
				constraints(nullable: "false")
			}

			column(name: "mailing_address_address2", type: "VARCHAR(255)") {
				constraints(nullable: "false")
			}

			column(name: "mailing_address_city", type: "VARCHAR(255)") {
				constraints(nullable: "false")
			}

			column(name: "mailing_address_country", type: "VARCHAR(2)") {
				constraints(nullable: "false")
			}

			column(name: "mailing_address_state", type: "VARCHAR(2)") {
				constraints(nullable: "false")
			}

			column(name: "mailing_address_zip_code", type: "VARCHAR(255)") {
				constraints(nullable: "false")
			}

			column(name: "name", type: "VARCHAR(255)") {
				constraints(nullable: "false")
			}

			column(name: "phone2", type: "VARCHAR(255)")

			column(name: "skype_id", type: "VARCHAR(255)")
		}
	}

	changeSet(author: "mark (generated)", id: "1358528772974-2") {
		createTable(tableName: "found_event") {
			column(autoIncrement: "true", name: "id", type: "BIGINT") {
				constraints(nullable: "false", primaryKey: "true")
			}

			column(name: "version", type: "BIGINT") {
				constraints(nullable: "false")
			}

			column(name: "can_contact_direct", type: "BIT")

			column(name: "description", type: "VARCHAR(255)") {
				constraints(nullable: "false")
			}

			column(name: "finder_contact_id", type: "BIGINT")

			column(name: "found_time", type: "DATETIME") {
				constraints(nullable: "false")
			}

			column(name: "handling_amount", type: "DECIMAL(19,2)")

			column(name: "item_id", type: "BIGINT") {
				constraints(nullable: "false")
			}

			column(name: "loc_lat", type: "FLOAT")

			column(name: "loc_long", type: "FLOAT")

			column(name: "location", type: "VARCHAR(255)") {
				constraints(nullable: "false")
			}

			column(name: "loser_contact_id", type: "BIGINT")

			column(name: "loser_respond_time", type: "DATETIME")

			column(name: "notify_finder_time", type: "DATETIME")

			column(name: "process_shipping", type: "BIT") {
				constraints(nullable: "false")
			}

			column(name: "reward_amount", type: "DECIMAL(19,2)")

			column(name: "shipping_amount", type: "DECIMAL(19,2)")

			column(name: "shipping_rate_id", type: "BIGINT")

			column(name: "venue", type: "VARCHAR(255)") {
				constraints(nullable: "false")
			}
		}
	}

	changeSet(author: "mark (generated)", id: "1358528772974-3") {
		createTable(tableName: "lost_event") {
			column(autoIncrement: "true", name: "id", type: "BIGINT") {
				constraints(nullable: "false", primaryKey: "true")
			}

			column(name: "version", type: "BIGINT") {
				constraints(nullable: "false")
			}

			column(name: "contact_id", type: "BIGINT") {
				constraints(nullable: "false")
			}

			column(name: "item_id", type: "BIGINT") {
				constraints(nullable: "false")
			}
		}
	}

	changeSet(author: "mark (generated)", id: "1358528772974-4") {
		createTable(tableName: "shipping_rate") {
			column(autoIncrement: "true", name: "id", type: "BIGINT") {
				constraints(nullable: "false", primaryKey: "true")
			}

			column(name: "version", type: "BIGINT") {
				constraints(nullable: "false")
			}

			column(name: "carrier", type: "VARCHAR(255)") {
				constraints(nullable: "false")
			}

			column(name: "package_type", type: "VARCHAR(255)") {
				constraints(nullable: "false")
			}

			column(name: "rate", type: "DECIMAL(19,2)") {
				constraints(nullable: "false")
			}

			column(name: "speed", type: "VARCHAR(255)") {
				constraints(nullable: "false")
			}
		}
	}

	changeSet(author: "mark (generated)", id: "1358528772974-5") {
		createTable(tableName: "sms") {
			column(autoIncrement: "true", name: "id", type: "BIGINT") {
				constraints(nullable: "false", primaryKey: "true")
			}

			column(name: "version", type: "BIGINT") {
				constraints(nullable: "false")
			}

			column(name: "from_col", type: "VARCHAR(12)")

			column(name: "message_body", type: "VARCHAR(255)") {
				constraints(nullable: "false")
			}

			column(name: "result", type: "VARCHAR(255)")

			column(name: "destination", type: "VARCHAR(25)") {
				constraints(nullable: "false")
			}

			column(name: "is_unicode", type: "BIT") {
				constraints(nullable: "false")
			}
		}
	}

	changeSet(author: "mark (generated)", id: "1358528772974-6") {
		addForeignKeyConstraint(baseColumnNames: "finder_contact_id", baseTableName: "found_event", baseTableSchemaName: "pijunn", constraintName: "FKF6D1439D8DFFED56", deferrable: "false", initiallyDeferred: "false", onDelete: "NO ACTION", onUpdate: "NO ACTION", referencedColumnNames: "id", referencedTableName: "contact", referencedTableSchemaName: "pijunn", referencesUniqueColumn: "false")
	}

	changeSet(author: "mark (generated)", id: "1358528772974-7") {
		addForeignKeyConstraint(baseColumnNames: "item_id", baseTableName: "found_event", baseTableSchemaName: "pijunn", constraintName: "FKF6D1439DE91AC416", deferrable: "false", initiallyDeferred: "false", onDelete: "NO ACTION", onUpdate: "NO ACTION", referencedColumnNames: "id", referencedTableName: "labeled_item", referencedTableSchemaName: "pijunn", referencesUniqueColumn: "false")
	}

	changeSet(author: "mark (generated)", id: "1358528772974-8") {
		addForeignKeyConstraint(baseColumnNames: "loser_contact_id", baseTableName: "found_event", baseTableSchemaName: "pijunn", constraintName: "FKF6D1439DA4E14D1F", deferrable: "false", initiallyDeferred: "false", onDelete: "NO ACTION", onUpdate: "NO ACTION", referencedColumnNames: "id", referencedTableName: "contact", referencedTableSchemaName: "pijunn", referencesUniqueColumn: "false")
	}

	changeSet(author: "mark (generated)", id: "1358528772974-9") {
		addForeignKeyConstraint(baseColumnNames: "shipping_rate_id", baseTableName: "found_event", baseTableSchemaName: "pijunn", constraintName: "FKF6D1439DB26577FA", deferrable: "false", initiallyDeferred: "false", onDelete: "NO ACTION", onUpdate: "NO ACTION", referencedColumnNames: "id", referencedTableName: "shipping_rate", referencedTableSchemaName: "pijunn", referencesUniqueColumn: "false")
	}

	changeSet(author: "mark (generated)", id: "1358528772974-10") {
		addForeignKeyConstraint(baseColumnNames: "contact_id", baseTableName: "lost_event", baseTableSchemaName: "pijunn", constraintName: "FKA304B1BF46E7839D", deferrable: "false", initiallyDeferred: "false", onDelete: "NO ACTION", onUpdate: "NO ACTION", referencedColumnNames: "id", referencedTableName: "contact", referencedTableSchemaName: "pijunn", referencesUniqueColumn: "false")
	}

	changeSet(author: "mark (generated)", id: "1358528772974-11") {
		addForeignKeyConstraint(baseColumnNames: "item_id", baseTableName: "lost_event", baseTableSchemaName: "pijunn", constraintName: "FKA304B1BFE91AC416", deferrable: "false", initiallyDeferred: "false", onDelete: "NO ACTION", onUpdate: "NO ACTION", referencedColumnNames: "id", referencedTableName: "labeled_item", referencedTableSchemaName: "pijunn", referencesUniqueColumn: "false")
	}
}
